﻿CREATE PROCEDURE [dbo].[sp_InsertSimulatedLOBEvent]
	@MeterNumber nvarchar(50),
	@MeterVendorID nvarchar(50),
	@MeterHeadEndID nvarchar(50),
	@TimeStamp datetime,
	@EventType nvarchar(50),
	@Reading float,
	@Temp float,
	@Code nvarchar(50),
	@Status nvarchar(50)
AS
	INSERT INTO [AMI].[dbo].[SimulatedLOB] WITH(ROWLOCK)
			(
			[MeterNumber]
			,[MeterVendorID]
			,[MeterHeadEndID]
			,[TimeStamp]
			,[EventType]
			,[Reading]
			,[Temp]
			,[Code]
			,[Status]
			,[PickedUp]
			)
		VALUES
			(
			@MeterNumber,
			@MeterVendorID,
			@MeterHeadEndID,
			@TimeStamp,
			@EventType,
			@Reading,
			@Temp,
			@Code,
			@Status,
			'Y'
			)
RETURN 0